CREATE TABLE [dbo].[TDCLAS_SUBR]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_ARUB] [dbo].[TD_VC_003] NOT NULL,
[CO_RUBR] [dbo].[TD_VC_003] NOT NULL,
[CO_CLSU] [dbo].[TD_VC_003] NOT NULL,
[CO_SUBR] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDCLAS_SU__CO_US__76B698BF] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDCLAS_SU__FE_US__77AABCF8] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDCLAS_SU__CO_US__789EE131] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDCLAS_SU__FE_US__7993056A] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDCLAS_SUBR] ADD CONSTRAINT [PK__TDCLAS_S__19F36B7E15BB0E23] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_ARUB], [CO_RUBR], [CO_CLSU]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDCLAS_SUBR] ADD CONSTRAINT [FK__TDCLAS_SUBR__351EAAE3] FOREIGN KEY ([CO_EMPR], [CO_ARUB], [CO_RUBR], [CO_CLSU]) REFERENCES [dbo].[TCCLAS_SUBR] ([CO_EMPR], [CO_ARUB], [CO_RUBR], [CO_CLSU])
GO
